-
Re: Index Match formula not working properly
Hello @Paul O Try adding "0" as your search type on your MATCH logic. The search type is the manner in which to search where "0" is not sorted. For order type =INDEX({DCS ORDER TR…2 · -
Re: Using symbols for assigned to
Hello @TPALJA A possible solution is create a helper column that will count the # of contacts on your Assigned To column using the COUNTM function. Sample formula on your helper column: =COUNTM([Assi…1 · -
Re: Count distinct values in a column if it falls within a date range
Hi @levnichk You can try this: =COUNT(DISTINCT(COLLECT({Site Receiving Transfer}, {Date Shipped}, AND(@cell >= [Start Date]@row, @cell <= [End Date]@row))))1 · -
Re: Convert Quarters to Date
Hello @MelissaYE Try this: =IF(LEFT([Quarter / Year]@row, 2) = "Q1", "03" + "/" + "31" + "/" + RIGHT([Quarter / Year]@row, 4), IF(LEFT([Quarter / Yea…1 · -
Re: COUNTIF with AND
Try COUNTIFS instead =COUNTIFS([Opportunity Risk Path]:[Opportunity Risk Path], "Conventional",[Module Approval Status]:[Module Approval Status], "Not Started")1 ·